package com.hl.mapper;

import com.hl.domain.Consultwait;
import com.hl.domain.Teacher;
import com.hl.domain.Teacherlevel;

import java.util.List;

/**
* @author Administrator
* @description 针对表【teacher(咨询师表，存储所有咨询师信息)】的数据库操作Mapper
* @createDate 2024-09-05 20:27:23
* @Entity com.hl.domain.Teacher
*/
public interface TeacherMapper {

    int deleteByPrimaryKey(Long id);

    int insert(Teacher record);

    int insertSelective(Teacher record);

    Teacher selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(Teacher record);

    int updateByPrimaryKey(Teacher record);

    //查询所有老师
    List<Teacher> findAllTeacher();
    List<Teacher> findAllAndChild();
    List<Teacher> findAllAndChild2();

    //查看所有咨询师
    List<Teacher> selectAllTeacher();

    //根据老师id查询等级
    Teacher selectLevelByTeacherId(int id);


    //小程序专用
    //查询所有老师，及相关信息
    List<Teacher> selectAllTeacherInfo();

    //根据老师id查询需要的信息
    Teacher selectAllById(int id);

    //根据老师id查询老师的收费标准，一个老师可以有多个收费标准
    List<Teacher> selectCharge(int id);

    //查询问题与恢复
    List<Teacher> selectProblemAndAnswer();

    //根据老师查询用户评价
    List<Teacher> selectUserMarkById(int id);


}
